﻿DECLARE @ManufacturerId int;
DECLARE @CategoryId int;
DECLARE @ProductId int;

INSERT [CSK_Store_Manufacturer] ([manufacturer], [createdOn], [createdBy], [modifiedOn], [modifiedBy]) 
VALUES (N'Sample Manufacturer', GetDate(), N'Commerce Installer', GetDate(), N'Commerce Installer')

SET @ManufacturerId = @@identity

INSERT [CSK_Store_Category] ([categoryName], [manufacturerID], [imageFile], [parentID], [shortDescription], [longDescription], [listOrder], [createdOn], [createdBy], [modifiedOn], [modifiedBy]) 
VALUES (N'Sample Category', NULL, NULL, NULL, NULL, NULL, 0, GetDate(), N'Commerce Installer', GetDate(), N'Commerce Installer')

SET @CategoryId = @@identity

INSERT [CSK_Store_Product] ([sku], [productGUID], [productName], [shortDescription], [manufacturerID], [attributeXML], [statusID], [productTypeID], [shippingTypeID], [shipEstimateID], [taxTypeID], [stockLocation], [ourPrice], [retailPrice], [weight], [currencyCode], [unitOfMeasure], [adminComments], [length], [height], [width], [dimensionUnit], [isDeleted], [listOrder], [ratingSum], [totalRatingVotes], [defaultImage], [createdOn], [createdBy], [modifiedOn], [modifiedBy]) 
VALUES (N'A Sample Product', N'41aa6fcd-fbe7-42e1-94d3-0a597dca8d52', N'A Sample Product', N'A Sample Product', @ManufacturerId, NULL, 1, 5, 1, 2, 1, NULL, 9.9900, 9.9900, CAST(2.0000 AS Numeric(19, 4)), N'161', N'each', N'', CAST(0 AS Numeric(18, 0)), CAST(0 AS Numeric(18, 0)), CAST(0 AS Numeric(18, 0)), N'each', 0, 99, 4, 1, N'', GetDate(), N'Commerce Installer', GetDate(), N'Commerce Installer')

SET @ProductId = @@identity

INSERT [CSK_Store_Product_Category_Map] ([productID], [categoryID], [listOrder], [isFeatured], [createdOn], [createdBy], [modifiedOn], [modifiedBy]) 
VALUES (@ProductId, @CategoryId, 1, 0, GetDate(), N'Commerce Installer', GetDate(), N'Commerce Installer')
